Specifying the sort order
This section describes how to change the sort order of records in Results.
|
To change the order in which Results sorts records: |
- Choose Data
Sort Ordering. The Sort Order Fields dialog box appears. - You can use up to 16 fields to sort the records in the query. To choose the sort fields, select the fields from the Available Fields selection list, then choose Add.
- The fields appear in the Selected Fields selection list. Note that the fields appear in the order in which Results uses them to sort the records:
- If you selected only one sort field or you are satisfied with the order of the sort fields, go to Step 5. Otherwise, to change the order of the sort fields, select one field at a time and choose either Move Up or Move Down.
- By default, the fields are sorted in ascending order. To sort a field in descending order, select the field, then choose Descending:
- When you are done setting the sort criteria, choose OK to update the sort order and redisplay the query.
Notice that the Available Fields selection list contains all the fields in the query. You can use any field to sort records, including some calculated fields and fields that are not displayed in the query view. The available calculated fields appear at the top of the Available Fields list:
